﻿using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;

namespace DoAnASP
{
    public class DAO_HoaDon
    {

        DAO_dataProvider kn = new DAO_dataProvider();
        public void ThemHoaDon()
        { 
        
        }

        public void XoaHoaDon()
        {

        }

        public void CapNhatHoaDon()
        {

        }

        // // lay toan bo hoa don len 
        public DataTable LoadHoaDon()
        {
            kn.ChuoiKetNoi();
            kn.Open_Connection();
            DataTable dt = new DataTable();
            SqlCommand cmd = new SqlCommand("select * from HoaDon",kn.conn);

            kn.Close_Connection();
            return dt;
        }
       
    }
}
